Printing an Invoice Cost Register

Once you have entered all of the required information needed to generate an Invoice Cost Register Report, command options will appear allowing you to print or choose from a set of other print options.

The report may be printed in summary or in detail.

The following prints in summary or detail for each invoice sorted by date and customer:

• Cust – The code or Id of the customer
• Inv # – The invoice number
• Ship Date – The date the order was shipped
• Invoice Date – The date the order was invoiced
• Order – The order number
• SP – The sales rep ID
• CUSTOMER PO – The customer purchase order number, if one was entered on the order
• AMOUNT INVOICED (PRODUCT) – The total extended product price charged for all items invoiced
• AMOUNT INVOICED (OTHER) – The total extended other price charged for all items invoiced
• AMOUNT INVOICED (TOTAL) – The total dollar amount invoiced; PRODUCT (the amount of product invoiced) plus Other (non-product items invoiced)
• COST – The total extended product cost attributed to the item

• GROSS PROFIT - The total dollar amount of profit based on the gross profit calculation method set in Ledger Options.
• MARGIN % - The gross profit expressed as a percentage of the total amount invoiced based on the gross margin calculation method set in Ledger Options.
• GRAND TOTAL - The grand total for each of the columns (headers) listed on the report.

Uncosted Items Page

Items that have been invoiced but have not yet been costed are itemized at the end of the report in a separate uncosted item report for customers above and below the line.

• SP - Sales Rep Id.
• BROKER -The broker ID, if you have selected Y in the Broker field.
• CUSTOMER - The customer code and name of the customer.
• ITEM - The item group and item name.
• ORDER - The sales order number.
• INVOICE - The invoice number if the order is invoiced.
• QUANTITY - The quantity of the item shipped to the customer.
• IN UN - The invoicing unit of measure.
• SELLING PRICE - The total per unit selling price of the item.
• EXTENDED - The dollar amount charged for the item. QUANTITY x SELLING PRICE = EXTENDED.

Note: A list of uncosted items will appear only if uncosted items exist.

For more information on using Invoice Cost Register option see Invoice Cost Register.

Security Required : System - Profit Margin